﻿alter proc AddDomains @ID int, @Dom_ID int,@Code int, @Title nvarchar(200), @Name nvarchar(200), @Priority int, @Description nvarchar(1000)  ,@IsActive bit, @Dom_ID_Type int
as  
begin  
 if not exists(select ID from domain where ID = @ID)  
  insert into domain (ID,Dom_ID,Code,Title,Name,Priority,Description,IsActive,Dom_ID_Type) values (@ID,@Dom_ID,@Code,@Title,@Name,@Priority,@Description,@IsActive,@Dom_ID_Type)  
 else  
  update domain set ID=@ID, Dom_ID=@Dom_ID,Code=@Code, Title=@Title, Name=@Name ,Priority=@Priority , Description =@Description, IsActive= @IsActive, Dom_ID_Type = @Dom_ID_Type  where ID = @ID
end  

